package priv.demo3.main;

import com.payment.lc.pcs.common.enums.CyclePeriodType;
import com.payment.lc.pcs.common.enums.MiProductCategory;
import com.payment.lc.pcs.common.enums.n.ProductLevel;
import com.payment.lc.pcs.common.util.CommonUtil;
import com.payment.lc.pcs.common.util.DateUtil;
import com.payment.lc.pcs.service.domain.Production;

import java.io.File;
import java.io.FileOutputStream;
import java.io.InputStream;
import java.io.ObjectOutputStream;
import java.math.BigDecimal;
import java.text.DecimalFormat;
import java.util.Date;
import java.util.Random;
import java.util.Scanner;
import java.util.regex.Matcher;
import java.util.regex.Pattern;

public class Main {
    public static void main(String[] args) throws Exception {
        String s = "SELECT DISTINCT\tp.production_code FROM\tt_product p,\tt_prod_period pe WHERE\tp.production_code = pe.production_code AND p.mi_main_category = 'FI'\n" +
                "AND p.mi_category = 'YueGuJiao'\n" +
                "AND p.delete_flag != 'D'\n" +
                "AND pe.delete_flag != 'D'\n" +
                "AND p.display_type = 'Up'\n" +
                "AND p.production_code NOT IN(17220057)\n" +
                "AND NOW() < pe.pur_close_time\n" +
                "ORDER BY\n" +
                "\tCASE\n" +
                "WHEN p.biz_status & 0x1 > 0\n" +
                "AND NOW() BETWEEN pe.pur_open_time\n" +
                "AND pe.pur_close_time THEN\t0 ELSE\t1 END,\n" +
                " pe.interest_rate DESC,\n" +
                " pe.pur_open_time\n" +
                "LIMIT 10,20;";

        System.out.println(s.replaceAll("\\n",""));


        System.out.println(CyclePeriodType.YEAR.equals(null));
    }

}